Assign Server Roles
Description
This step assigns one or more server-level roles to a login user on SQL Server. You provide the username and the roles to assign. Use this step in workflows that manage database permissions, grant elevated access during provisioning, or update user roles based on job function changes.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Name of the step. This name has to be unique in a single workflow. |
| Connection: | ||
| 2 | Server name | The IP address of remote machine on which MSSQL server instance is present should be given. |
| 3 | Instance name | The instance name of the MSSQL server should be provided. If we provide Instance name, Port number field will get disabled. |
| 4 | Port | The port number of the MSSQL server should be provided. If we provide Port number, there is no need to provide Instance name. Port number should only be an integer. |
| 5 | Username | The login username of MSSQL server to authenticate. |
| 6 | Password | Specify or select the password, as required. If the checkbox Accept Value as variable/static is selected, then the password field appears as a text box and accepts static or variable values. OR If the checkbox Accept Value as variable/static is not selected, then the password field appears as a dropdown in which you can select a field from the previous steps. |
| 7 | Other Connection Parameter | Specify multiple, semi-colon separated parameters other than the default connection parameters. Other connection parameters will be appended to the default connection parameters. Example of default connection parameters: Server Name, Password. Examples of other connection parameters: encrypt=false;trustServerCertificate=false |
| Button: | ||
| 8 | Test Connection | Verifies whether the connection is established or not. NOTE: Test Connection button does not work for Previous step fields. Test Connection button only works with static values and environment variables. |
| Input Tab | ||
| Input Fields: | ||
| 1 | Server Roles | Name of the Server Roles which is to be given to the user. This plugin is designed to assign single server role at a time. |
| 2 | Get Roles Button | Clicking on this button brings a dialog for the available Roles on that particular SQL server instance |
| 3 | Login Users | The login user on which the role is to be applied. |
| 4 | Get Users | Clicking on this button brings a dialog for the available Login Users on that particular SQL server instance |
| Output Tab | ||
| Output Fields: | ||
| 1 | Result | Output field to hold the result of the successful plugin execution. For step error handling refer Error Handling |